Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 1224 |
| Missing cells | 841 |
| Missing cells (%) | 5.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 124.4 KiB |
| Average record size in memory | 104.1 B |
Variable types
| Numeric | 9 |
|---|---|
| Text | 2 |
| Categorical | 1 |
| DateTime | 1 |
popularity is highly overall correlated with sellers_amount | High correlation |
best_price is highly overall correlated with lowest_price and 3 other fields | High correlation |
lowest_price is highly overall correlated with best_price and 3 other fields | High correlation |
highest_price is highly overall correlated with best_price and 3 other fields | High correlation |
sellers_amount is highly overall correlated with popularity | High correlation |
screen_size is highly overall correlated with best_price and 5 other fields | High correlation |
memory_size is highly overall correlated with best_price and 3 other fields | High correlation |
battery_size is highly overall correlated with screen_size | High correlation |
os is highly overall correlated with screen_size | High correlation |
os is highly imbalanced (78.4%) | Imbalance |
os has 197 (16.1%) missing values | Missing |
lowest_price has 260 (21.2%) missing values | Missing |
highest_price has 260 (21.2%) missing values | Missing |
memory_size has 112 (9.2%) missing values | Missing |
Unnamed: 0 is uniformly distributed | Uniform |
popularity is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
popularity has unique values | Unique |
Reproduction
| Analysis started | 2023-10-22 10:43:57.248418 |
|---|---|
| Analysis finished | 2023-10-22 10:44:10.526957 |
| Duration | 13.28 seconds |
| Software version | ydata-profiling vv4.6.0 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
UNIFORM UNIQUE
| Distinct | 1224 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 611.5 |
| Minimum | 0 |
|---|---|
| Maximum | 1223 |
| Zeros | 1 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 61.15 |
| Q1 | 305.75 |
| median | 611.5 |
| Q3 | 917.25 |
| 95-th percentile | 1161.85 |
| Maximum | 1223 |
| Range | 1223 |
| Interquartile range (IQR) | 611.5 |
Descriptive statistics
| Standard deviation | 353.48267 |
|---|---|
| Coefficient of variation (CV) | 0.57805834 |
| Kurtosis | -1.2 |
| Mean | 611.5 |
| Median Absolute Deviation (MAD) | 306 |
| Skewness | 0 |
| Sum | 748476 |
| Variance | 124950 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | 0.1% |
| 813 | 1 | 0.1% |
| 820 | 1 | 0.1% |
| 819 | 1 | 0.1% |
| 818 | 1 | 0.1% |
| 817 | 1 | 0.1% |
| 816 | 1 | 0.1% |
| 815 | 1 | 0.1% |
| 814 | 1 | 0.1% |
| 812 | 1 | 0.1% |
| Other values (1214) | 1214 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 1223 | 1 | |
| 1222 | 1 | |
| 1221 | 1 | |
| 1220 | 1 | |
| 1219 | 1 | |
| 1218 | 1 | |
| 1217 | 1 | |
| 1216 | 1 | |
| 1215 | 1 | |
| 1214 | 1 |
brand_name
Text
| Distinct | 64 |
|---|---|
| Distinct (%) | 5.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.7 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 6.0580065 |
| Min length | 2 |
Characters and Unicode
| Total characters | 7415 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 1.0% |
Sample
| 1st row | ALCATEL |
|---|---|
| 2nd row | ALCATEL |
| 3rd row | ALCATEL |
| 4th row | ALCATEL |
| 5th row | Nokia |
| Value | Count | Frequency (%) |
| samsung | 168 | 13.2% |
| xiaomi | 111 | 8.7% |
| apple | 102 | 8.0% |
| motorola | 62 | 4.9% |
| sigma | 52 | 4.1% |
| mobile | 52 | 4.1% |
| huawei | 49 | 3.8% |
| nokia | 48 | 3.8% |
| doogee | 44 | 3.4% |
| blackview | 42 | 3.3% |
| Other values (55) | 546 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 714 | 9.6% |
| a | 552 | 7.4% |
| i | 547 | 7.4% |
| e | 481 | 6.5% |
| m | 457 | 6.2% |
| l | 408 | 5.5% |
| n | 331 | 4.5% |
| S | 271 | 3.7% |
| u | 249 | 3.4% |
| g | 241 | 3.3% |
| Other values (41) | 3164 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5256 | |
| Uppercase Letter | 2088 | 28.2% |
| Space Separator | 52 | 0.7% |
| Decimal Number | 14 | 0.2% |
| Dash Punctuation | 5 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 714 | |
| a | 552 | |
| i | 547 | |
| e | 481 | |
| m | 457 | |
| l | 408 | 7.8% |
| n | 331 | 6.3% |
| u | 249 | 4.7% |
| g | 241 | 4.6% |
| s | 234 | 4.5% |
| Other values (14) | 1042 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 271 | |
| A | 236 | |
| E | 220 | 10.5% |
| O | 190 | 9.1% |
| G | 125 | 6.0% |
| M | 118 | 5.7% |
| X | 111 | 5.3% |
| U | 99 | 4.7% |
| H | 85 | 4.1% |
| N | 79 | 3.8% |
| Other values (14) | 554 |
Space Separator
| Value | Count | Frequency (%) |
| 52 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 14 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7344 | |
| Common | 71 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 714 | 9.7% |
| a | 552 | 7.5% |
| i | 547 | 7.4% |
| e | 481 | 6.5% |
| m | 457 | 6.2% |
| l | 408 | 5.6% |
| n | 331 | 4.5% |
| S | 271 | 3.7% |
| u | 249 | 3.4% |
| g | 241 | 3.3% |
| Other values (38) | 3093 |
Common
| Value | Count | Frequency (%) |
| 52 | ||
| 2 | 14 | 19.7% |
| - | 5 | 7.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7415 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 714 | 9.6% |
| a | 552 | 7.4% |
| i | 547 | 7.4% |
| e | 481 | 6.5% |
| m | 457 | 6.2% |
| l | 408 | 5.5% |
| n | 331 | 4.5% |
| S | 271 | 3.7% |
| u | 249 | 3.4% |
| g | 241 | 3.3% |
| Other values (41) | 3164 |
model_name
Text
| Distinct | 1068 |
|---|---|
| Distinct (%) | 87.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.7 KiB |
Length
| Max length | 67 |
|---|---|
| Median length | 48 |
| Mean length | 27.07598 |
| Min length | 3 |
Characters and Unicode
| Total characters | 33141 |
|---|---|
| Distinct characters | 70 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 930 ? |
|---|---|
| Unique (%) | 76.0% |
Sample
| 1st row | 1 1/8GB Bluish Black (5033D-2JALUAA) |
|---|---|
| 2nd row | 1 5033D 1/16GB Volcano Black (5033D-2LALUAF) |
| 3rd row | 1 5033D 1/16GB Volcano Black (5033D-2LALUAF) |
| 4th row | 1 5033D 1/16GB Volcano Black (5033D-2LALUAF) |
| 5th row | 1.3 1/16GB Charcoal |
| Value | Count | Frequency (%) |
| black | 589 | 10.3% |
| galaxy | 167 | 2.9% |
| 4/64gb | 163 | 2.8% |
| blue | 156 | 2.7% |
| pro | 125 | 2.2% |
| iphone | 102 | 1.8% |
| dual | 88 | 1.5% |
| redmi | 87 | 1.5% |
| 6/128gb | 84 | 1.5% |
| sim | 78 | 1.4% |
| Other values (1149) | 4098 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4513 | 13.6% | |
| B | 1832 | 5.5% |
| G | 1599 | 4.8% |
| a | 1505 | 4.5% |
| l | 1431 | 4.3% |
| 2 | 1232 | 3.7% |
| e | 1230 | 3.7% |
| 1 | 1140 | 3.4% |
| 0 | 926 | 2.8% |
| 6 | 858 | 2.6% |
| Other values (60) | 16875 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 11114 | |
| Uppercase Letter | 8151 | |
| Decimal Number | 7466 | |
| Space Separator | 4513 | |
| Other Punctuation | 767 | 2.3% |
| Close Punctuation | 394 | 1.2% |
| Open Punctuation | 394 | 1.2% |
| Dash Punctuation | 299 | 0.9% |
| Math Symbol | 43 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 1832 | |
| G | 1599 | |
| S | 690 | 8.5% |
| M | 567 | 7.0% |
| P | 513 | 6.3% |
| A | 384 | 4.7% |
| D | 281 | 3.4% |
| F | 232 | 2.8% |
| N | 220 | 2.7% |
| R | 215 | 2.6% |
| Other values (16) | 1618 |
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 1505 | |
| l | 1431 | |
| e | 1230 | |
| i | 773 | 7.0% |
| c | 759 | 6.8% |
| o | 739 | 6.6% |
| r | 694 | 6.2% |
| k | 649 | 5.8% |
| n | 438 | 3.9% |
| t | 416 | 3.7% |
| Other values (16) | 2480 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 1232 | |
| 1 | 1140 | |
| 0 | 926 | |
| 6 | 858 | |
| 4 | 704 | |
| 8 | 703 | |
| 5 | 617 | |
| 3 | 567 | |
| 9 | 433 | 5.8% |
| 7 | 286 | 3.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 749 | |
| . | 17 | 2.2% |
| ; | 1 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 4513 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 394 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 394 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 299 |
Math Symbol
| Value | Count | Frequency (%) |
| + | 43 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 19265 | |
| Common | 13876 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 1832 | 9.5% |
| G | 1599 | 8.3% |
| a | 1505 | 7.8% |
| l | 1431 | 7.4% |
| e | 1230 | 6.4% |
| i | 773 | 4.0% |
| c | 759 | 3.9% |
| o | 739 | 3.8% |
| r | 694 | 3.6% |
| S | 690 | 3.6% |
| Other values (42) | 8013 |
Common
| Value | Count | Frequency (%) |
| 4513 | ||
| 2 | 1232 | 8.9% |
| 1 | 1140 | 8.2% |
| 0 | 926 | 6.7% |
| 6 | 858 | 6.2% |
| / | 749 | 5.4% |
| 4 | 704 | 5.1% |
| 8 | 703 | 5.1% |
| 5 | 617 | 4.4% |
| 3 | 567 | 4.1% |
| Other values (8) | 1867 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 33141 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4513 | 13.6% | |
| B | 1832 | 5.5% |
| G | 1599 | 4.8% |
| a | 1505 | 4.5% |
| l | 1431 | 4.3% |
| 2 | 1232 | 3.7% |
| e | 1230 | 3.7% |
| 1 | 1140 | 3.4% |
| 0 | 926 | 2.8% |
| 6 | 858 | 2.6% |
| Other values (60) | 16875 |
os
Categorical
HIGH CORRELATION IMBALANCE MISSING
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 197 |
| Missing (%) | 16.1% |
| Memory size | 9.7 KiB |
| Android | |
|---|---|
| iOS | |
| OxygenOS | 3 |
| WindowsPhone | 3 |
| EMUI | 2 |
Length
| Max length | 12 |
|---|---|
| Median length | 7 |
| Mean length | 6.6085686 |
| Min length | 3 |
Characters and Unicode
| Total characters | 6787 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Android |
|---|---|
| 2nd row | Android |
| 3rd row | Android |
| 4th row | Android |
| 5th row | Android |
Common Values
| Value | Count | Frequency (%) |
| Android | 915 | |
| iOS | 103 | 8.4% |
| OxygenOS | 3 | 0.2% |
| WindowsPhone | 3 | 0.2% |
| EMUI | 2 | 0.2% |
| KAIOS | 1 | 0.1% |
| (Missing) | 197 | 16.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| android | 915 | |
| ios | 103 | 10.0% |
| oxygenos | 3 | 0.3% |
| windowsphone | 3 | 0.3% |
| emui | 2 | 0.2% |
| kaios | 1 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| d | 1833 | |
| i | 1021 | |
| n | 924 | |
| o | 921 | |
| A | 916 | |
| r | 915 | |
| O | 110 | 1.6% |
| S | 107 | 1.6% |
| e | 6 | 0.1% |
| y | 3 | < 0.1% |
| Other values (12) | 31 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5638 | |
| Uppercase Letter | 1149 | 16.9% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| d | 1833 | |
| i | 1021 | |
| n | 924 | |
| o | 921 | |
| r | 915 | |
| e | 6 | 0.1% |
| y | 3 | 0.1% |
| g | 3 | 0.1% |
| x | 3 | 0.1% |
| w | 3 | 0.1% |
| Other values (2) | 6 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 916 | |
| O | 110 | 9.6% |
| S | 107 | 9.3% |
| W | 3 | 0.3% |
| P | 3 | 0.3% |
| I | 3 | 0.3% |
| E | 2 | 0.2% |
| M | 2 | 0.2% |
| U | 2 | 0.2% |
| K | 1 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6787 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| d | 1833 | |
| i | 1021 | |
| n | 924 | |
| o | 921 | |
| A | 916 | |
| r | 915 | |
| O | 110 | 1.6% |
| S | 107 | 1.6% |
| e | 6 | 0.1% |
| y | 3 | < 0.1% |
| Other values (12) | 31 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6787 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| d | 1833 | |
| i | 1021 | |
| n | 924 | |
| o | 921 | |
| A | 916 | |
| r | 915 | |
| O | 110 | 1.6% |
| S | 107 | 1.6% |
| e | 6 | 0.1% |
| y | 3 | < 0.1% |
| Other values (12) | 31 | 0.5% |
popularity
Real number (ℝ)
HIGH CORRELATION UNIFORM UNIQUE
| Distinct | 1224 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 612.5 |
| Minimum | 1 |
|---|---|
| Maximum | 1224 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 62.15 |
| Q1 | 306.75 |
| median | 612.5 |
| Q3 | 918.25 |
| 95-th percentile | 1162.85 |
| Maximum | 1224 |
| Range | 1223 |
| Interquartile range (IQR) | 611.5 |
Descriptive statistics
| Standard deviation | 353.48267 |
|---|---|
| Coefficient of variation (CV) | 0.57711457 |
| Kurtosis | -1.2 |
| Mean | 612.5 |
| Median Absolute Deviation (MAD) | 306 |
| Skewness | 0 |
| Sum | 749700 |
| Variance | 124950 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 422 | 1 | 0.1% |
| 669 | 1 | 0.1% |
| 717 | 1 | 0.1% |
| 937 | 1 | 0.1% |
| 781 | 1 | 0.1% |
| 1127 | 1 | 0.1% |
| 945 | 1 | 0.1% |
| 267 | 1 | 0.1% |
| 255 | 1 | 0.1% |
| 963 | 1 | 0.1% |
| Other values (1214) | 1214 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 1224 | 1 | |
| 1223 | 1 | |
| 1222 | 1 | |
| 1221 | 1 | |
| 1220 | 1 | |
| 1219 | 1 | |
| 1218 | 1 | |
| 1217 | 1 | |
| 1216 | 1 | |
| 1215 | 1 |
best_price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 970 |
|---|---|
| Distinct (%) | 79.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7941.2067 |
| Minimum | 214 |
|---|---|
| Maximum | 56082 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 214 |
|---|---|
| 5-th percentile | 499 |
| Q1 | 2599.75 |
| median | 4728 |
| Q3 | 9323 |
| 95-th percentile | 27995.1 |
| Maximum | 56082 |
| Range | 55868 |
| Interquartile range (IQR) | 6723.25 |
Descriptive statistics
| Standard deviation | 8891.8363 |
|---|---|
| Coefficient of variation (CV) | 1.1197085 |
| Kurtosis | 4.7255408 |
| Mean | 7941.2067 |
| Median Absolute Deviation (MAD) | 2679 |
| Skewness | 2.0936991 |
| Sum | 9720037 |
| Variance | 79064752 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2999 | 8 | 0.7% |
| 2299 | 5 | 0.4% |
| 4099 | 5 | 0.4% |
| 252 | 5 | 0.4% |
| 3490 | 4 | 0.3% |
| 5299 | 4 | 0.3% |
| 1699 | 4 | 0.3% |
| 3590 | 4 | 0.3% |
| 499 | 4 | 0.3% |
| 2399 | 4 | 0.3% |
| Other values (960) | 1177 |
| Value | Count | Frequency (%) |
| 214 | 1 | 0.1% |
| 220 | 1 | 0.1% |
| 235 | 1 | 0.1% |
| 241 | 2 | 0.2% |
| 249 | 4 | |
| 252 | 5 | |
| 272 | 2 | 0.2% |
| 273 | 1 | 0.1% |
| 275 | 1 | 0.1% |
| 279 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 56082 | 1 | |
| 55338 | 1 | |
| 51460 | 1 | |
| 49242 | 1 | |
| 46503 | 1 | |
| 46325 | 1 | |
| 44716 | 1 | |
| 44232 | 1 | |
| 42968 | 1 | |
| 42649 | 1 |
lowest_price
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 666 |
|---|---|
| Distinct (%) | 69.1% |
| Missing | 260 |
| Missing (%) | 21.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7716.0187 |
| Minimum | 198 |
|---|---|
| Maximum | 49999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 198 |
|---|---|
| 5-th percentile | 447 |
| Q1 | 2399 |
| median | 4574 |
| Q3 | 9262.25 |
| 95-th percentile | 27224.65 |
| Maximum | 49999 |
| Range | 49801 |
| Interquartile range (IQR) | 6863.25 |
Descriptive statistics
| Standard deviation | 8560.9591 |
|---|---|
| Coefficient of variation (CV) | 1.1095047 |
| Kurtosis | 3.805784 |
| Mean | 7716.0187 |
| Median Absolute Deviation (MAD) | 2810.5 |
| Skewness | 1.9415716 |
| Sum | 7438242 |
| Variance | 73290020 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4999 | 9 | 0.7% |
| 3549 | 8 | 0.7% |
| 499 | 8 | 0.7% |
| 3199 | 6 | 0.5% |
| 699 | 6 | 0.5% |
| 2199 | 6 | 0.5% |
| 2999 | 6 | 0.5% |
| 599 | 6 | 0.5% |
| 899 | 5 | 0.4% |
| 3399 | 5 | 0.4% |
| Other values (656) | 899 | |
| (Missing) | 260 | 21.2% |
| Value | Count | Frequency (%) |
| 198 | 1 | 0.1% |
| 199 | 1 | 0.1% |
| 209 | 1 | 0.1% |
| 218 | 2 | 0.2% |
| 219 | 1 | 0.1% |
| 220 | 5 | |
| 222 | 1 | 0.1% |
| 227 | 2 | 0.2% |
| 239 | 2 | 0.2% |
| 259 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 49999 | 1 | |
| 45799 | 1 | |
| 45120 | 1 | |
| 44809 | 1 | |
| 44199 | 1 | |
| 43396 | 1 | |
| 42999 | 1 | |
| 41996 | 1 | |
| 39620 | 1 | |
| 37639 | 1 |
highest_price
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 648 |
|---|---|
| Distinct (%) | 67.2% |
| Missing | 260 |
| Missing (%) | 21.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9883.4108 |
| Minimum | 229 |
|---|---|
| Maximum | 69999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 229 |
|---|---|
| 5-th percentile | 561.5 |
| Q1 | 2887 |
| median | 5325.5 |
| Q3 | 12673.75 |
| 95-th percentile | 34945.15 |
| Maximum | 69999 |
| Range | 69770 |
| Interquartile range (IQR) | 9786.75 |
Descriptive statistics
| Standard deviation | 11514.937 |
|---|---|
| Coefficient of variation (CV) | 1.1650772 |
| Kurtosis | 4.2056208 |
| Mean | 9883.4108 |
| Median Absolute Deviation (MAD) | 3430 |
| Skewness | 2.026239 |
| Sum | 9527608 |
| Variance | 1.3259377 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3299 | 8 | 0.7% |
| 8999 | 7 | 0.6% |
| 3999 | 7 | 0.6% |
| 7999 | 6 | 0.5% |
| 3399 | 6 | 0.5% |
| 4499 | 6 | 0.5% |
| 7499 | 5 | 0.4% |
| 2099 | 5 | 0.4% |
| 8499 | 5 | 0.4% |
| 1049 | 5 | 0.4% |
| Other values (638) | 904 | |
| (Missing) | 260 | 21.2% |
| Value | Count | Frequency (%) |
| 229 | 2 | 0.2% |
| 259 | 1 | 0.1% |
| 289 | 2 | 0.2% |
| 291 | 2 | 0.2% |
| 299 | 1 | 0.1% |
| 314 | 1 | 0.1% |
| 317 | 1 | 0.1% |
| 329 | 1 | 0.1% |
| 330 | 1 | 0.1% |
| 333 | 5 |
| Value | Count | Frequency (%) |
| 69999 | 1 | |
| 64999 | 1 | |
| 59999 | 2 | |
| 57999 | 1 | |
| 56999 | 1 | |
| 53731 | 1 | |
| 51999 | 1 | |
| 50999 | 1 | |
| 50760 | 1 | |
| 50670 | 1 |
sellers_amount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 94 |
|---|---|
| Distinct (%) | 7.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.743464 |
| Minimum | 1 |
|---|---|
| Maximum | 125 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 8 |
| Q3 | 26 |
| 95-th percentile | 55 |
| Maximum | 125 |
| Range | 124 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 20.597006 |
|---|---|
| Coefficient of variation (CV) | 1.230152 |
| Kurtosis | 5.3094121 |
| Mean | 16.743464 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 2.075041 |
| Sum | 20494 |
| Variance | 424.23667 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 235 | |
| 2 | 119 | 9.7% |
| 3 | 72 | 5.9% |
| 4 | 57 | 4.7% |
| 5 | 45 | 3.7% |
| 10 | 36 | 2.9% |
| 6 | 35 | 2.9% |
| 8 | 34 | 2.8% |
| 11 | 29 | 2.4% |
| 9 | 26 | 2.1% |
| Other values (84) | 536 |
| Value | Count | Frequency (%) |
| 1 | 235 | |
| 2 | 119 | |
| 3 | 72 | 5.9% |
| 4 | 57 | 4.7% |
| 5 | 45 | 3.7% |
| 6 | 35 | 2.9% |
| 7 | 24 | 2.0% |
| 8 | 34 | 2.8% |
| 9 | 26 | 2.1% |
| 10 | 36 | 2.9% |
| Value | Count | Frequency (%) |
| 125 | 2 | |
| 120 | 1 | |
| 117 | 1 | |
| 115 | 1 | |
| 112 | 1 | |
| 111 | 1 | |
| 109 | 1 | |
| 105 | 1 | |
| 102 | 2 | |
| 101 | 1 |
screen_size
Real number (ℝ)
HIGH CORRELATION
| Distinct | 82 |
|---|---|
| Distinct (%) | 6.7% |
| Missing | 2 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.3943781 |
| Minimum | 1.4 |
|---|---|
| Maximum | 8.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 1.4 |
|---|---|
| 5-th percentile | 2.2 |
| Q1 | 5.1625 |
| median | 6 |
| Q3 | 6.4 |
| 95-th percentile | 6.7 |
| Maximum | 8.1 |
| Range | 6.7 |
| Interquartile range (IQR) | 1.2375 |
Descriptive statistics
| Standard deviation | 1.4769913 |
|---|---|
| Coefficient of variation (CV) | 0.27380197 |
| Kurtosis | 0.65931067 |
| Mean | 5.3943781 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -1.3955878 |
| Sum | 6591.93 |
| Variance | 2.1815034 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5.5 | 103 | 8.4% |
| 2.4 | 81 | 6.6% |
| 6.5 | 78 | 6.4% |
| 6.3 | 60 | 4.9% |
| 5 | 58 | 4.7% |
| 6.1 | 58 | 4.7% |
| 6.4 | 58 | 4.7% |
| 5.7 | 53 | 4.3% |
| 1.77 | 39 | 3.2% |
| 2.8 | 39 | 3.2% |
| Other values (72) | 595 |
| Value | Count | Frequency (%) |
| 1.4 | 2 | 0.2% |
| 1.44 | 5 | 0.4% |
| 1.77 | 39 | |
| 1.8 | 11 | 0.9% |
| 2 | 4 | 0.3% |
| 2.2 | 8 | 0.7% |
| 2.3 | 1 | 0.1% |
| 2.4 | 81 | |
| 2.8 | 39 | |
| 3 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 8.1 | 1 | 0.1% |
| 7.6 | 1 | 0.1% |
| 7.3 | 4 | 0.3% |
| 7.12 | 4 | 0.3% |
| 6.9 | 8 | |
| 6.88 | 1 | 0.1% |
| 6.82 | 2 | 0.2% |
| 6.81 | 2 | 0.2% |
| 6.8 | 11 | |
| 6.78 | 2 | 0.2% |
memory_size
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 15 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 112 |
| Missing (%) | 9.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95.700059 |
| Minimum | 0.0032 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 0.0032 |
|---|---|
| 5-th percentile | 0.032 |
| Q1 | 32 |
| median | 64 |
| Q3 | 128 |
| 95-th percentile | 256 |
| Maximum | 1000 |
| Range | 999.9968 |
| Interquartile range (IQR) | 96 |
Descriptive statistics
| Standard deviation | 111.92258 |
|---|---|
| Coefficient of variation (CV) | 1.1695142 |
| Kurtosis | 15.218553 |
| Mean | 95.700059 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 3.1958657 |
| Sum | 106418.47 |
| Variance | 12526.663 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 64 | 295 | |
| 128 | 285 | |
| 32 | 179 | |
| 16 | 122 | |
| 256 | 85 | 6.9% |
| 0.032 | 62 | 5.1% |
| 512 | 36 | 2.9% |
| 8 | 19 | 1.6% |
| 4 | 8 | 0.7% |
| 0.004 | 6 | 0.5% |
| Other values (5) | 15 | 1.2% |
| (Missing) | 112 | 9.2% |
| Value | Count | Frequency (%) |
| 0.0032 | 3 | 0.2% |
| 0.004 | 6 | 0.5% |
| 0.016 | 4 | 0.3% |
| 0.032 | 62 | 5.1% |
| 0.064 | 4 | 0.3% |
| 0.128 | 1 | 0.1% |
| 4 | 8 | 0.7% |
| 8 | 19 | 1.6% |
| 16 | 122 | |
| 32 | 179 |
| Value | Count | Frequency (%) |
| 1000 | 3 | 0.2% |
| 512 | 36 | 2.9% |
| 256 | 85 | 6.9% |
| 128 | 285 | |
| 64 | 295 | |
| 32 | 179 | |
| 16 | 122 | |
| 8 | 19 | 1.6% |
| 4 | 8 | 0.7% |
| 0.128 | 1 | 0.1% |
battery_size
Real number (ℝ)
HIGH CORRELATION
| Distinct | 151 |
|---|---|
| Distinct (%) | 12.4% |
| Missing | 10 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3608.2018 |
| Minimum | 460 |
|---|---|
| Maximum | 18800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 9.7 KiB |
Quantile statistics
| Minimum | 460 |
|---|---|
| 5-th percentile | 950 |
| Q1 | 2900 |
| median | 3687 |
| Q3 | 4400 |
| 95-th percentile | 5580 |
| Maximum | 18800 |
| Range | 18340 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 1668.2688 |
|---|---|
| Coefficient of variation (CV) | 0.46235462 |
| Kurtosis | 10.686759 |
| Mean | 3608.2018 |
| Median Absolute Deviation (MAD) | 772 |
| Skewness | 1.7042709 |
| Sum | 4380357 |
| Variance | 2783120.7 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4000 | 158 | 12.9% |
| 5000 | 109 | 8.9% |
| 3000 | 87 | 7.1% |
| 4500 | 54 | 4.4% |
| 800 | 40 | 3.3% |
| 3500 | 40 | 3.3% |
| 3400 | 30 | 2.5% |
| 1000 | 26 | 2.1% |
| 3300 | 24 | 2.0% |
| 2000 | 22 | 1.8% |
| Other values (141) | 624 |
| Value | Count | Frequency (%) |
| 460 | 2 | 0.2% |
| 600 | 17 | |
| 650 | 1 | 0.1% |
| 800 | 40 | |
| 950 | 2 | 0.2% |
| 970 | 6 | 0.5% |
| 1000 | 26 | |
| 1020 | 6 | 0.5% |
| 1050 | 4 | 0.3% |
| 1150 | 2 | 0.2% |
| Value | Count | Frequency (%) |
| 18800 | 1 | 0.1% |
| 15800 | 1 | 0.1% |
| 13000 | 1 | 0.1% |
| 11000 | 4 | 0.3% |
| 10300 | 1 | 0.1% |
| 10000 | 10 | |
| 9000 | 3 | 0.2% |
| 8000 | 3 | 0.2% |
| 7000 | 1 | 0.1% |
| 6600 | 3 | 0.2% |
release_date
Date
| Distinct | 73 |
|---|---|
| Distinct (%) | 6.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 9.7 KiB |
| Minimum | 2013-01-01 00:00:00 |
|---|---|
| Maximum | 2021-02-01 00:00:00 |
Histogram with fixed size bins (bins=50)
| Unnamed: 0 | popularity | best_price | lowest_price | highest_price | sellers_amount | screen_size | memory_size | battery_size | os | |
|---|---|---|---|---|---|---|---|---|---|---|
| Unnamed: 0 | 1.000 | 0.102 | 0.162 | 0.156 | 0.177 | 0.099 | -0.029 | 0.090 | -0.048 | 0.449 |
| popularity | 0.102 | 1.000 | 0.396 | 0.423 | 0.448 | 0.516 | 0.405 | 0.370 | 0.275 | 0.131 |
| best_price | 0.162 | 0.396 | 1.000 | 0.996 | 0.996 | 0.107 | 0.664 | 0.856 | 0.434 | 0.222 |
| lowest_price | 0.156 | 0.423 | 0.996 | 1.000 | 0.989 | 0.067 | 0.669 | 0.853 | 0.417 | 0.251 |
| highest_price | 0.177 | 0.448 | 0.996 | 0.989 | 1.000 | 0.115 | 0.646 | 0.838 | 0.401 | 0.255 |
| sellers_amount | 0.099 | 0.516 | 0.107 | 0.067 | 0.115 | 1.000 | 0.088 | 0.194 | 0.052 | 0.194 |
| screen_size | -0.029 | 0.405 | 0.664 | 0.669 | 0.646 | 0.088 | 1.000 | 0.650 | 0.723 | 0.504 |
| memory_size | 0.090 | 0.370 | 0.856 | 0.853 | 0.838 | 0.194 | 0.650 | 1.000 | 0.395 | 0.149 |
| battery_size | -0.048 | 0.275 | 0.434 | 0.417 | 0.401 | 0.052 | 0.723 | 0.395 | 1.000 | 0.226 |
| os | 0.449 | 0.131 | 0.222 | 0.251 | 0.255 | 0.194 | 0.504 | 0.149 | 0.226 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| Unnamed: 0 | brand_name | model_name | os | popularity | best_price | lowest_price | highest_price | sellers_amount | screen_size | memory_size | battery_size | release_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | ALCATEL | 1 1/8GB Bluish Black (5033D-2JALUAA) | Android | 422 | 1690.0 | 1529.0 | 1819.0 | 36 | 5.00 | 8.0 | 2000.0 | 10-2020 |
| 1 | 1 | ALCATEL | 1 5033D 1/16GB Volcano Black (5033D-2LALUAF) | Android | 323 | 1803.0 | 1659.0 | 2489.0 | 36 | 5.00 | 16.0 | 2000.0 | 9-2020 |
| 2 | 2 | ALCATEL | 1 5033D 1/16GB Volcano Black (5033D-2LALUAF) | Android | 299 | 1803.0 | 1659.0 | 2489.0 | 36 | 5.00 | 16.0 | 2000.0 | 9-2020 |
| 3 | 3 | ALCATEL | 1 5033D 1/16GB Volcano Black (5033D-2LALUAF) | Android | 287 | 1803.0 | 1659.0 | 2489.0 | 36 | 5.00 | 16.0 | 2000.0 | 9-2020 |
| 4 | 4 | Nokia | 1.3 1/16GB Charcoal | Android | 1047 | 1999.0 | NaN | NaN | 10 | 5.71 | 16.0 | 3000.0 | 4-2020 |
| 5 | 5 | Honor | 10 6/64GB Black | Android | 71 | 10865.0 | 10631.0 | 11099.0 | 2 | 5.80 | 64.0 | 3400.0 | 6-2018 |
| 6 | 6 | Honor | 10 Lite 3/32GB Blue | Android | 424 | 3999.0 | NaN | NaN | 2 | 6.21 | 32.0 | 3400.0 | 12-2018 |
| 7 | 7 | Honor | 10 Lite 4/64GB Black | Android | 134 | 4973.0 | 4733.0 | 5295.0 | 6 | 6.21 | 64.0 | 3400.0 | 1-2019 |
| 8 | 8 | Honor | 10 lite 3/128GB Blue | Android | 477 | 5100.0 | 4990.0 | 5222.0 | 3 | 6.21 | 128.0 | 3400.0 | 1-2021 |
| 9 | 9 | Honor | 10 lite 3/64GB Black | Android | 215 | 4948.0 | 4646.0 | 5372.0 | 8 | 6.21 | 64.0 | 3400.0 | 12-2018 |
| Unnamed: 0 | brand_name | model_name | os | popularity | best_price | lowest_price | highest_price | sellers_amount | screen_size | memory_size | battery_size | release_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1214 | 1214 | Apple | iPhone XS 256GB Gold (MT9K2) | iOS | 1126 | 21463.0 | 15281.0 | 25617.0 | 68 | 5.80 | 256.0 | 2568.0 | 9-2018 |
| 1215 | 1215 | Apple | iPhone XS 512GB Silver (MT9M2) | iOS | 803 | 22842.0 | 17832.0 | 27500.0 | 62 | 5.80 | 512.0 | 2568.0 | 9-2018 |
| 1216 | 1216 | Apple | iPhone XS 64GB Space Gray (MT9E2) | iOS | 1187 | 19790.0 | 12505.0 | 23928.0 | 53 | 5.80 | 64.0 | 2568.0 | 9-2018 |
| 1217 | 1217 | Apple | iPhone XS Max 256GB Gold (MT552) | iOS | 1128 | 24184.0 | 18399.0 | 30600.0 | 37 | 6.50 | 256.0 | 3174.0 | 9-2018 |
| 1218 | 1218 | Apple | iPhone XS Max 512GB Space Gray (MT622) | iOS | 842 | 27190.0 | 21150.0 | 30200.0 | 47 | 6.50 | 512.0 | 3174.0 | 9-2018 |
| 1219 | 1219 | Apple | iPhone XS Max 64GB Gold (MT522) | iOS | 1101 | 22685.0 | 16018.0 | 27900.0 | 61 | 6.50 | 64.0 | 3174.0 | 9-2018 |
| 1220 | 1220 | Apple | iPhone XS Max Dual Sim 64GB Gold (MT732) | iOS | 530 | 24600.0 | 21939.0 | 33720.0 | 28 | 6.50 | 64.0 | 3174.0 | 9-2018 |
| 1221 | 1221 | HUAWEI | nova 5T 6/128GB Black (51094MEU) | Android | 1174 | 8804.0 | 7999.0 | 9999.0 | 18 | 6.26 | 128.0 | 3750.0 | 11-2019 |
| 1222 | 1222 | ZTE | nubia Red Magic 5G 8/128GB Black | Android | 752 | 18755.0 | 18500.0 | 19010.0 | 2 | 6.65 | 128.0 | 4500.0 | 10-2020 |
| 1223 | 1223 | Sigma mobile | x-style 35 Screen | NaN | 952 | 907.0 | 785.0 | 944.0 | 75 | 3.50 | NaN | 1750.0 | 1-2020 |